﻿CREATE TABLE [dbo].[ASMS_Staff]
(
	[Id] uniqueidentifier NOT NULL PRIMARY KEY,
	[Name] nvarchar(32) NOT NULL,
	[Account] nvarchar(32) NOT NULL,
	[Password] nvarchar(32) NOT NULL,
	[Telephone] nvarchar(32) NOT NULL,
	[AvatarImage] nvarchar(256),
	[IdNumber] nvarchar(32) not null,
	[EMail] nvarchar(128),
	[BusinessId] uniqueidentifier null,
	[Description] nvarchar(256),
	[Pinyin] nvarchar(64),
	[Letter] nvarchar(16),
	[Status] int NOT NULL,
	[CreatedTime] datetime NOT NULL,
	[Creator] nvarchar(64) NOT NULL
)
